<?php require_once($_SERVER['DOCUMENT_ROOT']."/defaultconf.mex");
MYTCONN(); ?>
<table width="100%"  border="0" cellpadding="1" cellspacing="3" bgcolor="#EAEAEA">
  <tr>
    <td height="23">Pedido</td>
    <td>Usuário</td>
    <td>Balcão</td>
	<td>Data</td>
    <td>Descrição</td>
    <td>Estado</td>
	<td>Prioridade</td>
	<td>Data Prevista Resolução</td>
	<td>Atribuido a</td>
  </tr>
  <?php
  $Qur = $GLOBALS['MYT']->db_array("SELECT ref,main_users_ref, main_office_ref, data, estado, problema, prioridade,
  data_reso, atribuido_a FROM systemoffice.it_requests");
  for($a = 1; $a<=$Qur[0]; $a++) { ?>
  <tr title="Detalhes: <?=$Qur[$a]['ref'];?>              RESPOSTA: <?=$Qur[$a]['ref'];?>">
    <td><?=$Qur[$a]['ref'];?></td>
    <td><?=$Qur[$a]['main_users_ref'];?></td>
    <td><?=$Qur[$a]['main_office_ref'];?></td>
    <td><?=$Qur[$a]['data'];?></td>
    <td><?=$Qur[$a]['problema'];?></td>
    <td><?=$Qur[$a]['estado'];?></td>
    <td><?=$Qur[$a]['prioridade'];?></td>
	<td><?=$Qur[$a]['data_reso'];?></td>
	<td><?=$Qur[$a]['atribuido_a'];?></td>
  </tr>
  <tr><td colspan="9"><hr size="1"></td></tr>
  <?php } ?>
</table>
</body>
</html>
